Import data from a webpage table

Problem:

I formatted some data as a webpage table in html. How could I import the data into File Maker Pro?

Solution:

This is very easy.

• In the browser save the webpage where the table is located as source.
• Open Microsoft Excel.
• In Excel open the document you just saved. It will become an Excel table.
• Delete all unwanted rows and columns, including the headers.
• Save the file as an Excel spreadsheet.
• Import the data into File Maker Pro (File Maker Pro can recognize Excel files).

Eevn if you have blanks in some cells, don't worry. File Maker Pro could import the data correctly. But you should still check the mapping between the field and the data in the preview data.

FMP Tips Contents Other computer tips Search Engine Credit/Copyright © Simplified Navigation Table of Contents

Contact Me