Create a CSV from a MeteoTemplate Database

Use this guide if you want a portable CSV export from MeteoTemplate before importing into Meteobreeze.

This guide assumes you are using phpMyAdmin to export the table. The data table you need is alldata.

This is the right path when you do not want a direct database connection, when you need to move data between systems, or when you want to inspect the file before importing it.

Recommended: connect your live source first, then export and import the CSV later. That way the station starts collecting fresh data immediately while you prepare the historical file.

When to use it

• You want to export data once and import it later
• You cannot connect Meteobreeze directly to the database
• You want to clean or review the file before import

What to include

Export a header row and keep one row per observation from the alldata table.

The most important column is DateTime. Additional columns can include values like:

• T
• Tmax
• Tmin
• H
• D
• W
• G
• B
• RR
• R
• P
• A

You do not need every MeteoTemplate column, but the timestamp column must be present.

Step-by-step

1. Open phpMyAdmin.
2. Select the MeteoTemplate database.
3. Open the alldata table.
4. Choose the Export tab.
5. Export the table as CSV.
6. Keep the column headers intact where possible.
7. Make sure timestamps are consistent across the file.
8. Check that the file uses commas or another delimiter you can import cleanly.
9. Use the CSV import guide in Meteobreeze to map and import the file.

Common issues

• If the import cannot find a timestamp, make sure DateTime was included in the export.
• If headers were renamed during export, you may need to map them manually in Meteobreeze.
• If the file looks correct in a spreadsheet but not during import, check the delimiter and quoting rules.
• If you export the wrong table, the CSV may not contain observation data at all.

FAQ

• Do I need to export every column? No.
• Can I clean the file before importing? Yes. That is one reason to use this path.

Related pages

• Import a CSV file
• Map fields, units, and timestamps
• Units

Image needed: a screenshot of phpMyAdmin with the alldata table selected and the CSV export settings visible.