Skip to main content

Export Websites Data

Overview​

This section explains how to import/export website data using a CSV file.
The CSV file must include the following 7 fields:

  • Name
  • Email
  • Website
  • Address
  • City
  • State
  • Zipcode

Step 1: Upload CSV File​

  • The user selects a CSV file from the system.
  • The first row of the CSV will be shown as options in dropdowns for mapping.

Example CSV file:

NameEmailWebsiteAddressCityStateZipcode
John Doejohn@email.comwww.test.com123 Main StreetNew YorkNY10001
Jane Smithjane@email.comwww.abc.com456 Elm StreetChicagoIL60601

Step 2: Field Mapping​

When the file is uploaded:

  • 7 select fields will be shown.
  • Each select field will contain the first row cells from the CSV file.
  • Example:

Select Fields and Options

The system provides multiple select fields in the CSV import/update interface. Each select field allows choosing one of the following options:

  • Options available for each select field:
    Name, Email, Website, Address, City, State, Zipcode

Example Fields​

  • Select Name → [ Name, Email, Website, Address, City, State, Zipcode ]
  • Select Email → [ Name, Email, Website, Address, City, State, Zipcode ]
  • Select Website → [ Name, Email, Website, Address, City, State, Zipcode ]
  • Select Address → [ Name, Email, Website, Address, City, State, Zipcode ]
  • Select City → [ Name, Email, Website, Address, City, State, Zipcode ]
  • Select State → [ Name, Email, Website, Address, City, State, Zipcode ]
  • Select Zipcode → [ Name, Email, Website, Address, City, State, Zipcode ]

Each select field reads the first row of the CSV for options and then maps the selected option to store the corresponding website data in the database.

This ensures the user can map CSV columns correctly to database fields.​

Step 3: Save to Database​

After mapping:

  • The system will store each row in the website_data table.
  • The table has the following structure: