TOPIC:

Exporting as excelsheet 3 weeks 1 day ago #259631

  • Topic Author
  • sdeveloper
  • Offline
  • Junior Breezer
  • Junior Breezer
  • Posts: 79
  • Thanks: 0
Hello All, Good day,Hope all you are safe and healthy, please I need your help in my Breezingform portal, I had been created this form ( marketing.sardargroup.com/landing-page/ ) in order to collect leads info according to digital marketing staff needs. The exporting option provides me (3) options (CSV, PDF, XML), when I exported the records as (CSV) I found that the data saved in this sheet was not arranged and everything mixed with other things please check the attached CSV image and if you need to take a look on CSV file I'll send you by email.I want to enhance the CSV option to export as columns and rows, each column has a title of each field (Name, Gender, City, .. etc) and under each column title contains the data of leads. Please, can anybody help me to solve this matter? Thanks
Attachments:

Please Log in or Create an account to join the conversation.

Exporting as excelsheet 3 weeks 1 day ago #259634

  • tihana.krivic's Avatar
  • tihana.krivic
  • Offline
  • Moderator
  • Moderator
  • Posts: 6086
  • Karma: 3
  • Thanks: 429

Please Log in or Create an account to join the conversation.

Exporting as excelsheet 3 weeks 1 day ago #259640

  • Topic Author
  • sdeveloper
  • Offline
  • Junior Breezer
  • Junior Breezer
  • Posts: 79
  • Thanks: 0
Thanks for the fast response
Unfortunately, this article not clear, it makes me confused, the writer didn't specify the files, root of the files that should fix it.

Please, can you help me to fix that?

Please Log in or Create an account to join the conversation.

Exporting as excelsheet 3 weeks 1 day ago #259641

  • tihana.krivic's Avatar
  • tihana.krivic
  • Offline
  • Moderator
  • Moderator
  • Posts: 6086
  • Karma: 3
  • Thanks: 429
Hi,

To read the .csv format as a spreadsheet in Excel, the data must be converted.

See here:
www.copytrans.net/support/how-to-open-a-csv-file-in-excel/

Regards,
Tihana

Please Log in or Create an account to join the conversation.

Exporting as excelsheet 3 weeks 1 day ago #259642

  • Topic Author
  • sdeveloper
  • Offline
  • Junior Breezer
  • Junior Breezer
  • Posts: 79
  • Thanks: 0
Thanks a lot,
But this article will be useful after I fix the problem of generating the titles of form as columns inside the CSV when I download it as a CSV, this is the exact issue that I want help in solving it.

Please Log in or Create an account to join the conversation.

Exporting as excelsheet 3 weeks 1 day ago #259646

  • tihana.krivic's Avatar
  • tihana.krivic
  • Offline
  • Moderator
  • Moderator
  • Posts: 6086
  • Karma: 3
  • Thanks: 429
Hi,

In fact, there is no problem, the csv format being only a simple TEXT file with tabulated data separated by commas.

This format can be opened by excel but its data must be converted to a table by excel in order to be placed in various cells.

There is no solution to my knowledge that allows this type of file to be opened in Excel with an immediate display as a table.

If you want to save your data directly in table form, you can use the BreezingForms GDATA plugin to send your data to a Google sheet which can then be downloaded in xslx Excel format without any conversion.

Regards,
Tihana

Please Log in or Create an account to join the conversation.

Time to create page: 0.052 seconds

BreezingForms Pro 1.4.7 for WordPress Released!

Available in the membership section.

September Discount!

Massive discounts on all subscriptions!

Get Your Subscription Here

Quick Links

Downloads

BreezingForms

ContentBuilder

BreezingCommerce

Templates

Documentation

BreezingForms

ContentBuilder

BreezingCommerce

Apprendre BreezingForms (French Community)

Apprendre et maîtriser BreezingForms par des tutoriels et exemples, le tout en français

breezingforms.eddy-vh.com

Questions et réponses sur les forums de l'AFUJ

AFUJ

Special Offer

Summer Sale! All subscriptions at a special price!

Includes prio support, all of our current and future Joomla!® extensions and Joomla!® templates for the duration of your membership.

Get it from here

3rd Party Discount - 25% Off

We help you to keep your costs under control. If you are a new member and purchased a form building tool from a different form vendor, then you'll get a 25% discount on our subscription plans.

How to receive the discount:

Send us a quick email to sales@crosstec.org with a proof of purchase (for example a paypal receipt), await payment instructions and enjoy your membership!